<html>

<head>

<title>EQ Emu - Character List</title>

<?php

$time_start = microtime(true);
include "../includes/constants.php";
include "../includes/functions.php";

if (!isset($_GET["limit"])) {
	$_GET["limit"] = 10;
};
if ((!isset($_GET["offset"]) || ($_GET["offset"] == ""))) {
	$_GET["offset"] = 0;
};

?>

</head>

<body>

<center><h1>Character List</h1></center>

<table align="center" border="1">
	<form method="GET" action="">
	<caption align="top" style="text-align:right">
		<?php CreateResultLimit();?>
<!--		<input type="text" size="1" name="limit" value="<?php echo $_GET["limit"];?>"> Per Page
		<input type="hidden" name="offset" value="<?php echo $_GET["offset"];?>">
		<input type="hidden" name="sort" value="<?php echo $_GET["sort"];?>">
		<input type="hidden" name="dir" value="<?php echo $_GET["dir"];?>">
		<a href="?limit=<?php echo $_GET["limit"];?>&offset=<?php if ($_GET["offset"] - $_GET["limit"] >= 0) {echo $_GET["offset"] - $_GET["limit"];};?>&sort=<?php echo $_GET["sort"];?>&dir=<?php echo $_GET["dir"];?>">&lt;&lt;Prev</a>&nbsp;
		<a href="?limit=<?php echo $_GET["limit"];?>&offset=<?php echo $_GET["offset"] + $_GET["limit"];?>&sort=<?php echo $_GET["sort"];?>&dir=<?php echo $_GET["dir"];?>">Next&gt;&gt;</a>
-->	</caption>
	<tr>
		<th><?php SortLink(id,'ID');?></th>
		<th><?php SortLink(account_name,'Acct');?></th>
		<th><?php SortLink(name,'Name');?></th>
		<th><?php SortLink(level,'Level','DESC');?></th>
		<th><?php SortLink('class','Class');?></th>
		<th><?php SortLink(zonename,'Zone Name');?></th>
<!--		<th><?php SortLink(pktime,'PK Time');?></th>		-->
		<th><?php SortLink(groupid,'Group ID','DESC');?></th>
		<th><?php SortLink(timelaston,'Last On','DESC');?></th>
		<th><?php SortLink(birthday,'Birthday','DESC');?></th>
	</tr>
<?php flush(); ob_flush();?>	<tr>
		<td align="right">
			<?php // CreateDropdown(id,character_);?>&nbsp;
		</td>
		<td>
			<?php // CreateDropdown(account_name,character_);?>&nbsp;
		</td>
		<td>
			<?php // CreateDropdown(name,character_);?>&nbsp;
		</td>
		<td>
			<?php // CreateDropdown(level,character_);?>&nbsp;
		</td>
		<td>
			<?php // CreateDropdown('class',character_);?>&nbsp;
		</td>
		<td>
			<?php CreateDropdown(zonename,character_);?>&nbsp;
		</td>
<!--		<td>
			<?php // CreateDropdown(pktime,character_);?>&nbsp;
		</td>
-->		<td align="right">
			<?php CreateDropdown(groupid,character_);?>
		</td>
		<td>
			<?php // CreateDropdown(timelaston,character_);?>&nbsp;
		</td>
		<td>
			<?php // CreateDropdown(birthday,character_);?>&nbsp;
		</td>
	</tr>
	</form>
<?php

if ($_GET["account_id"] != "") {
	$where = " WHERE character_.account_id=" . $_GET["account_id"] . " ";
};
if (!isset($_GET["sort"]) || ($_GET["sort"] == "")) {
	$_GET["sort"] = "timelaston";
};
if (!isset($_GET["dir"]) || ($_GET["dir"] == "")) {
	$_GET["dir"] = "DESC";
};
$query1 = "SELECT character_.id, account.name AS account_name, character_.account_id, character_.name, character_.timelaston, character_.x, character_.y, character_.z, character_.zonename, character_.zoneid, character_.pktime, character_.groupid, character_.class, character_.level, CONV(CONCAT(LPAD(BIN(ASCII(SUBSTRING(character_.profile,232,1))),8,'0'),LPAD(BIN(ASCII(SUBSTRING(character_.profile,231,1))),8,'0'),LPAD(BIN(ASCII(SUBSTRING(character_.profile,230,1))),8,'0'),LPAD(BIN(ASCII(SUBSTRING(character_.profile,229,1))),8,'0')),2,10) AS  birthday FROM character_ LEFT JOIN account ON account.id=character_.account_id" . $where . " ORDER BY " . $_GET["sort"] . " " . $_GET["dir"] . " ";
// Limit query if $_GET["limit"] is set
if ($_GET["limit"] != "") {
	$query1 .= " LIMIT " . $_GET["limit"] . " OFFSET " . $_GET["offset"] . " ";
};
$result1 = mysql_query($query1,$db);
// echo $query1 . "<br>\n";

// Display data if any found, message if none found

if ($db_row1 = mysql_fetch_array($result1)) {
	do {
		// Find out how many characters the account has
		global $db;
		$query_chars = "SELECT COUNT(id) AS id FROM character_ WHERE account_id='" . $db_row1["account_id"] . "'";
		$result_chars = mysql_query($query_chars,$db);
		$db_row_chars = mysql_fetch_array($result_chars);

		echo "\t<tr>
		<td align=\"right\">" . $db_row1["id"] . "</td>
		<td title=\"ID: " . $db_row1["account_id"] . "\"><a href=\"../account/?id=" . $db_row1["account_id"] . "\">" . $db_row1["account_name"] . "</a> (<a href=\"?account_id=" . $db_row1["account_id"] . "\">" . $db_row_chars["id"] . "</a>)</td>
		<td><a href=\"../inventory/?id=" . $db_row1["id"] . "\">" . $db_row1["name"] . "</a></td>
		<td align=\"right\">" . $db_row1["level"] . "</td>
		<td>" . $Classes["{$db_row1["class"]}"] . "</td>
		<td title=\"X: " . $db_row1["x"] . "\nY: " . $db_row1["y"] . "\nZ: " . $db_row1["z"] . "\">" . $db_row1["zonename"] . "</td>
<!--		<td>" . $db_row1["pktime"] . "</td>		-->
		<td align=\"right\">" . $db_row1["groupid"] . "</td>
		<td>" . date("Y-m-d H:i:s",$db_row1["timelaston"]) . "</td>
		<td>" . date("Y-m-d H:i:s",$db_row1["birthday"]) . "</td>
	</tr>\n";
	flush(); ob_flush();
	} while ($db_row1 = mysql_fetch_array($result1));
} else {
	echo "\t\t<td align=\"center\" colspan=\"11\">No records found</td>
	</tr>";
};

?>
</table>

<?php

include "../includes/footer.php";

?>

</body>

</html>
